Model Table SERVICE CONTRACT
This model dimension represents service contract line information and is based
on the IFS Cloud dimension DIM_SERVICE_CONTRACT_LINE. All models that
refers to this dimension will have the attributes and hierarchies as described
below.
Attributes
| Attribute |
Description (where applicable) |
| Service Contract | The service contract id (CONTRACT_ID) |
| Service Contract Connection Type | The connection type (CONNECTION_TYPE) |
| Service Contract Coordinator | The name of the contract coordinator (CORRDINATOR_NAME) |
| Service Contract Currency | Contract currency code (CURRENCY_CODE) |
| Service Contract Customer | Customer name (CUSTOMER_NAME) |
| Service Contract Fixed Catalog | Defined as the fixed catalog description (FIXED_CATALOG_DESC) |
| Service Contract Invoice Catalog | Defined as the invoice catalog description (INVOICE_CATALOG_DESC) |
| Service Contract Invoice Rule | Defined as the invoice rule description (INVOICE_RULE_DESC) |
| Service Contract Invoice Type | Invoice type (client value) |
| Service Contract Line | Key. Defined as CONTRACT_ID + ' - ' + CODE + ' - ' + DESCRIPTION. CODE represents the line number. |
| Service Contract Manager | The name of the contract manager. ( CONTRACT_MANAGER_NAME) |
| Service Contract Name | The contract name (CONTRACT_NAME) |
| Service Contract Type | Defines as the contract type description (CONTRACT_TYPE_DESC) |
| Service Contract Work Type | Defined as the contract work type description (WORK_TYPE_DESC) |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| SERVICE CONTRACT | DIM_SERVICE_CONTRACT_LINE_TM | DIM_SERVICE_CONTRACT_LINE_BI | DIM_SERVICE_CONTRACT_LINE | On Line |